

USE [bmig_Mensual_Post_cadena]
GO

IF EXISTS (SELECT name FROM   sysobjects WHERE  name = 'WASP_M0011_CARGATBL_CodValSalud' AND type = 'P')
    DROP PROCEDURE [dbo].[WASP_M0011_CARGATBL_CodValSalud]
GO

CREATE PROCEDURE [dbo].[WASP_M0011_CARGATBL_CodValSalud]

AS


BEGIN 
		INSERT INTO codvalSalud
		
		SELECT cs.ppsuc, cs.ppcta, cs.ppoper,
			   vs.ppimp11 as cod_seg1 , cs.ppimp11 as val_seg1,
			   vs.ppimp12 as cod_seg2, cs.ppimp12 as val_seg2,
			   vs.ppimp13 as cod_seg3, cs.ppimp13 as val_seg3,
			   vs.ppimp14 as cod_seg4, cs.ppimp14 as val_seg4,
			   vs.ppimp15 as cod_seg5, cs.ppimp15 as val_seg5,
			   vs.ppimp16 as cod_seg6, cs.ppimp16 as val_seg6,
			   vs.ppimp17 as cod_seg7, cs.ppimp17 as val_seg7, 
			   vs.ppimp18 as cod_seg8, cs.ppimp18 as val_seg8,
			   vs.ppimp19 as cod_seg9, cs.ppimp19 as val_seg9
		
		FROM  valsegSalud as cs,
			  codsegSalud as vs
		
		WHERE cs.ppsuc  = vs.ppsuc and
			  cs.ppcta  = vs.ppcta and 
			  cs.ppoper = vs.ppoper
	
		
END